Search results 60

Card image cap
Excel user name

Get application user name or change it Originally from

Card image cap
ANmaInt

Cuts the integer part of a number. Like INT, FIX, or CINT I know we already ...

Card image cap
Filename_Clean

Returns cleaned file name of invalid characters. Needs to be modified if used ...

Card image cap
Shape_Select_or_CreateThenSelect

Selects a shape inside sheet to change it, or if not found, it will create it ...

Card image cap
DBTables

Returns an array of all table names in a database. needs valid OLE database ...

Card image cap
CleanFilename

Cleans file name from invalid unexpected characters that Windows refuses.

Card image cap
ShapeName clicked

Simple command to know which object (shape) the user clicked When you assign a ...

Card image cap
UISetup + UIRestore

Simple way to freeze UI in Excel-VBA then restore it after complete in standard ...

Card image cap
HTMLTagAttributeValue

Reads value of certain tag attribute from certain attribute Identify attribute ...

Card image cap
ClearHistory10_20

Delete folders named in format [PDFs-2020-12-05] in certain folder along with ...

Card image cap
Long filename

How to delete or rename file with long filename, say more than 200 chars. ...

Card image cap
SortedFiles

Get a sorted list of files in a directory using the File System Object (FSO) ...